Dashboard 03 - ZipCode - Creating Line and Clustered Column charts Visualizations - Part 01 17
In this step, we will create a map and charts in the 3rd dashboard / page.
Step 1: Create Line and Clustered Column Chart for AVG Year Over Year (YOY) Apartment & House Prices/Sq. Ft. by Property (Description) Desc
In Power BI Desktop, click on the page, ZipCode
If selected, de-select a visualization by clicking an empty area of the report page.
Visualizations
Click the Line and Clustered Column Chart icon
Fields
Select the following:
Under Visualizations, drag & drop it in the Shared Axis section:
Type_and_Use -> Type_Use_Description
DateDimension[Date] -> Year
Under Visualizations, drag & drop it in the Column Values section:
A_KeyMeasures -> .AVG_ResidentialPrice_PerSqFt%
Under Visualizations, drag & drop it in the Line Values section:
A_KeyMeasures -> .YOY_AVG_ResidentialPrice_PerSqFt%
Under Visualizations, drag & drop it in the Tooltips section:
A_KeyMeasures -> .YOY_Diff_AVG_ResidentialPrice_PerSqFt%
A_KeyMeasures -> .AVG_Residential_Prices
Visualizations
Fields tab
Under Fields tab, click on the down arrow -> Rename for this visual and rename the fields as follows:
Type_Use_Description = Property Type Description
.AVG_ResidentialPrice_PerSqFt% = AVG House Price/Sq. Ft.
.YOY_AVG_ResidentialPrice_PerSqFt% = YOY AVG House Price/Sq. Ft.
.YOY_Diff_AVG_ResidentialPrice_PerSqFt% = YOY AVG House Price/Sq. Ft.
.AVG_Residential_Prices = AVG House Price
Format tab
To format the visual, beneath the Visualizations pane, select the Format pane.
Under Format -> General: X Position = 924 , Y Position = 171 , Width = 576 , Height = 428
Under Format -> Legend -> Set it to ON , Position = Top Center , Title = OFF , Color = #000000 , Legend Name = [blank] , Font Family = Segoe UI , Text Size = 13 pt , Style = Markers Only
Under Format -> X Axis -> Color = #000000 , Text Size = 11 pt , Font Family = Segoe UI , Title = OFF
Under Format -> Y Axis -> Position = Left , Scale Type = Linear -> Start = Auto , Color = #000000 , Text Size = 11 pt , Font Family = Segoe UI , Title = OFF , Gridlines = ON , Line Color = #000000 , Stroke Width = 2 , Line Style = Dotted , Show Secondary = ON , Y-Axis (Line) Position = Right , Scale Type = Linear , Color = #5B8F22 , Text Size = 12 pt , Font Family = Segoe UI , Title = OFF
Under Format -> Data Colors ->
YOY AVG Hse Price/Sq. Ft. = #925231
Default Color = #DC8250
Under Format -> Data Labels -> Set it to ON , Color = #000000 , Display Units = Auto , Value Decimal Places = 0 , Text Size = 14 pt , Font Family = Segoe UI , Show Background = Off ,
Customize Series = ON ,
(Select AVG Hse Price/Sq. Ft. -> Show = ON , Color = #000000 , Display Units = Auto , Value Decimal Values = 0 , Text Size = 14 , Font Family = Segoe UI , Show Background = OFF)
(Select YOY AVG Hse Price/Sq. Ft. -> Show = ON , Color = #000000 , Display Units = Auto , Value Decimal Values = 0 , Text Size = 14 , Font Family = Segoe UI , Show Background = OFF)
Under Format -> Shapes -> Shade Area = ON , Stroke Width = 2 , Join Type = Round , Line Style = Solid , Show Marker = ON , Marker Shape = . (dot) , Marker Size = 5
Under Format -> Title -> Set it to ON , Title Text = Average & YOY House Price/Sq. Ft. by Property Desc , Font Color = #1D0C4A , Background Color = #E6E6E6 , Alignment = Center , Text Size = 20 pt , Font Family = DIN (Default)
Under Format -> Background -> Set it to ON , Color = #FFFFFF
Under Format -> Border -> Set it to OFF
Step 2 - Configure Filter(s)
Filters
None.
When finished, save project.
Tips and Tricks for Maps in Power BI